Search TipsAverage Revenue Per Customer & Account Type
|
Report Name |
Average Revenue Per Customer & Account Type |
|
|
Objective |
This is a monthly spend report per Account for a calendar month. Additional output summarises spend by Account Type (Customer Category such as low, medium, or high risk) to show average spend. |
|
|
Expected Frequency |
Monthly |
|
|
Period |
Previous Calendar Month |
|
|
Output File(s) |
AVERAGE REVENUE PER CUSTOMER AND ACCOUNT TYPE_YYYYMMDD.csv |
|
|
Output Fields |
Name | Description |
|---|---|---|
| Group Code | CMP code for the group | |
| Corporate Code | CMP code fr the corporate | |
| Account Number | ID number for the account | |
| Account Type | The type of account | |
| Invoice Count | The number of invoices for the account | |
| Total (Ex. Vat) | The total spend excluding VAT | |
| Total Vat | The total spend including VAT | |
| Total Spend | The total spend | |
| Average Spend Per Account | The average spend per account | |
|
Job Schedule Information |
Schedule: Monthly (1st) |
|